﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DocManagerORM.ORM
{
   public  class QueryUsers:QueryBase
    {

       public IQueryable<aspnet_Roles> getRUOLI()
       {
           var ret = m_Entity.aspnet_Roles.Where(c => c.Visible == true);  
           return ret ;
       }

       public IQueryable<aspnet_Membership> getMEMBERSHIP(bool pIsLockedOut)
       {
           var ret = m_Entity.aspnet_Membership.Where(c => c.IsLockedOut == pIsLockedOut);
           return ret;
       }

       public IQueryable<aspnet_Membership> getMEMBERSHIP(string pUserName)
       {
           var ret = m_Entity.aspnet_Membership.Where(c => c.aspnet_Users.UserName == pUserName );
           return ret;
       }

       public IQueryable<vwMembershipSimple> getVwMembershipSimple(bool pIsLockedOut)
       {
           var ret = m_Entity.vwMembershipSimple.Where(c => c.IsLockedOut == pIsLockedOut);
           return ret;
       }


          

    }//fC
}
